﻿<hibernate-mapping default-cascade="none" xmlns="urn:nhibernate-mapping-2.2">
  <class name="Northwind.Entities.Order, Northwind.Entities" table="Orders">
    <id name="OrderID" type="System.Int32" column="OrderID" unsaved-value="0">
      <generator class="native" />
    </id>
    <property name="Freight" type="System.Decimal" column="Freight" not-null="false" />
    <property name="OrderDate" type="System.DateTime" column="OrderDate" not-null="false" />
    <property name="RequiredDate" type="System.DateTime" column="RequiredDate" not-null="false" />
    <property name="ShipAddress" type="System.String" column="ShipAddress" not-null="false" />
    <property name="ShipCity" type="System.String" column="ShipCity" not-null="false" />
    <property name="ShipCountry" type="System.String" column="ShipCountry" not-null="false" />
    <property name="ShipName" type="System.String" column="ShipName" not-null="false" />
    <property name="ShippedDate" type="System.DateTime" column="ShippedDate" not-null="false" />
    <property name="ShipPostalCode" type="System.String" column="ShipPostalCode" not-null="false" />
    <property name="ShipRegion" type="System.String" column="ShipRegion" not-null="false" />
    <many-to-one name="Customer" class="Northwind.Entities.Customer, Northwind.Entities" fetch="select">
      <column name="CustomerID" not-null="false" />
    </many-to-one>
    <many-to-one name="Employee" class="Northwind.Entities.Employee, Northwind.Entities" fetch="select">
      <column name="EmployeeID" not-null="false" />
    </many-to-one>
    <bag name="OrderDetails" inverse="true" lazy="true" cascade="none">
      <key>
        <column name="OrderID" not-null="true" />
      </key>
      <one-to-many class="Northwind.Entities.OrderDetail, Northwind.Entities" />
    </bag>
    <many-to-one name="Shipper" class="Northwind.Entities.Shipper, Northwind.Entities" fetch="select">
      <column name="ShipVia" not-null="false" />
    </many-to-one>
  </class>
</hibernate-mapping>
